SaStudSubsidiaryStatementHistory

Logical Entity Name | SaStudSubsidiaryStatementHistory
Default Table Name | SaStudSubsidiaryStatementHistory
Physical Only | NO
Owner | dbo
Definition |
Note |

SaStudSubsidiaryStatementHistory Columns

ColumnName | Domain | Datatype | NULL | Definition
SaStudSubsidiaryStatementHistoryID |  | int | NO |
SaStudSubsidiaryID |  | int | NO |
Balance |  | money | YES |
MinBalance |  | money | YES |
AmountDue |  | money | YES |
ClosingDate |  | datetime | NO |
UserId |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
TS |  | timestamp | NO |
StudentName |  | varchar(376) | YES |
NameStudent |  | varchar(376) | YES |
StudentAddr |  | varchar(255) | YES |
StudentCity |  | varchar(100) | YES |
StudentState |  | char(2) | YES |
StudentZip |  | char(20) | YES |
StudentPhone |  | char(16) | YES |
PrintID |  | nvarchar(30) | YES |
PrintIdType |  | int | YES |
SyStudentID |  | int | YES |
StuNum |  | varchar(30) | YES |
ProgramDescrip |  | nvarchar(150) | YES |
StartDate |  | datetime | YES |
SubsidiaryDescrip |  | varchar(50) | YES |
Status |  | varchar(35) | YES |
Subsidiary |  | varchar(50) | YES |
SchoolName |  | varchar(50) | YES |
CampusPhone |  | varchar(16) | YES |
SyCampusID |  | int | YES |
IncMaintainBalance |  | char(1) | YES |
ShowCoupon |  | char(1) | YES |
IncEnrollInform |  | char(1) | YES |
RemAddr |  | varchar(255) | YES |
RemCity |  | varchar(25) | YES |
RemState |  | varchar(2) | YES |
RemZip |  | varchar(10) | YES |
CampusPhone2 |  | varchar(16) | YES |
CampusPhone3 |  | varchar(16) | YES |
AdEnrollID |  | int | YES |
SchAddr |  | varchar(255) | YES |
SchCity |  | char(25) | YES |
SchState |  | char(2) | YES |
SchZip |  | char(10) | YES |
CreditCardList |  | varchar(200) | YES |
PrintComment |  | varchar(1100) | YES |

SaStudSubsidiaryStatementHistory Primary and Unique Keys

Key Name | Key Type | Keys
PK_SaStudSubsidiaryStatementHistory_SaStudSubsidiaryStatementHistoryID | PrimaryKey | SaStudSubsidiaryStatementHistoryID

SaStudSubsidiaryStatementHistory Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SaStudSubsidiary | Non-Identifying | One To Zero or More | FK_SaStudSubsidiaryStatementHistory_SaStudSubsidiaryID_SaStudSubsidiary_SaStudSubsidiaryID |  |  | SaStudSubsidiaryID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SaStudSubsidiaryStatementHistory_UserId_SyStaff_SyStaffID |  |  | UserId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SaStudSubsidiaryStatementHistoryTrans | Non-Identifying | One To Zero or More | FK_SaStudSubsHistoryTrans_SaStudSubsidiaryStatementHistoryID_SaStudSubsHistory_SaStudSubsidiaryStatementHistoryID |  |  |  | NO | YES

SaStudSubsidiaryStatementHistory Check Constraints

Check Constraint Name | CheckConstraint

SaStudSubsidiaryStatementHistory Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaStudSubsidiaryStatementHistory Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentSubsidiaryStatement | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaStudSubsidiaryStatementHistory | NO |  |  |

SaStudSubsidiaryStatementHistory Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | SubsidiaryLedger
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaStudSubsidiaryStatementHistory Data Movement Rules

Name | Type | Rule Text/Value